package com.noahplat.person.mapper;

import com.noahplat.person.pojo.SecondDepart;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

/**
 * @InterfaceName: SecondDepartMapper
 * @Description: 科室二级分类mapper
 * @Author 李景星
 * @Date 2021/3/6
 * @Version 1.0
 */
public interface SecondDepartMapper extends Mapper<SecondDepart> {
    @Select("select s.id,s.fid,s.second_depart as sdepart,f.id as firstid,f.first_depart as fdepart from enum_first_depart f left join enum_second_depart s on f.id = s.fid")
    List<SecondDepart> selectDepart();
}
